---
title: DB-CLL-044 — Resolve a secretary/ALJ display name for a schedule entry
summary: Resolve a secretary/ALJ display name for a schedule entry
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-044 — Resolve a secretary ALJ display name for a schedule entry

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-044 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsLegalSchedule |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| SecretaryEmplid | Input | VARCHAR2 | N/A | Employee ID of the secretary/ALJ to resolve a display name for |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_SCHEDULE](../database-tables.md#legal_schedule-schedule-(proc-target-unclear)) | SELECT | join key |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | display name columns |

## Sample SQL

```sql
Select
  ADP_EMPLOYEE.EMPLOYEE_NAME
From
  ADP_EMPLOYEE
Where
  ADP_EMPLOYEE.EMPLID = :SecretaryEmplid
```

## Operations and processes

- [Manage legal schedule and hearing calendar](../operations/manage-legal-schedule.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)
- [BR-CLM-LGL-025](../business-rules.md#br-clm-lgl-025-consolidation-schedule-non-production-behavior-suppression)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsLegalSchedule.vb`